﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="admin_12count.aspx.cs" Inherits="Web.admin_12count" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>12个月份统计</title>
  <script type="text/javascript" src="js/My97DatePicker/WdatePicker.js"></script>
   <link href="css/Page.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript">
    
      function batchPrint() {

          
                  window.open("admin_monthprint.aspx");
            
          }      
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
  

   <table style="border: 1px solid #9abddd;" border="0" cellpadding="0" cellspacing="0" width="98%">
            <tr>
                <td colspan="13" class="TitleBar"  align="center">
                  统计信息
                </td>
            </tr>
          <tr>
                <td class="Pager" colspan="12" style="padding-right: 30px; text-align:left; ">
               &nbsp;&nbsp;&nbsp;
                    年份：<asp:TextBox ID="BeginDataTime" runat="server" onclick="new WdatePicker({dateFmt:'yyyy-MM-dd'});" Width="100px" TabIndex="10"></asp:TextBox>
                    
                     项目分类：
                     <asp:DropDownList ID="ddlItemType" runat="server" TabIndex="4" Width="70px" >
                    </asp:DropDownList>
                          账户：
                     <asp:DropDownList ID="ddlBankType" runat="server" TabIndex="5" Width="70px" >
                    </asp:DropDownList>
                             部门：
                     <asp:DropDownList ID="ddldepartType" runat="server" TabIndex="6" Width="70px" >
                    </asp:DropDownList>
                    操作人：
                    <asp:DropDownList ID="ddlPoper" runat="server" TabIndex="7" Width="70px" >
                    </asp:DropDownList>
                    
                    <asp:Button runat="server" ID="btn_ok" Text="查询" onclick="btn_ok_Click1"  />
                   
                   <input type="button" id="btBatchPrint" value="打印" onclick="batchPrint()" />
                   
                </td>
                <td class="Pager"  style="padding-right: 30px; text-align:left; ">
                 <asp:Button ID="btn_out" runat="server" onclick="btn_out_Click" 
                        style="height: 26px" Text="导出Excel" />
                </td>
                
            </tr>
            <tr><td colspan="13"  class="TitleBar"  align="center"> 现金日记账 </td> </tr>
            
              <tr>
                <td class="MenuItem" align="center">
                    项目
                </td>
                
                  <td class="MenuItem" align="center">
                    一月
                </td>
                  <td class="MenuItem" align="center">
                    二月
                </td>
                  <td class="MenuItem" align="center">
                   三月
                </td>
                  <td class="MenuItem" align="center">
                   四月
                </td>
                  <td class="MenuItem" align="center">
                   五月
                </td>
                  <td class="MenuItem" align="center">
                  六月
                </td>
                  <td class="MenuItem" align="center">
                   七月
                </td>
                  <td class="MenuItem" align="center">
                   八月
                </td>
                  <td class="MenuItem" align="center">
                   九月
                </td>
                  <td class="MenuItem" align="center">
                   十月
                </td>
                  <td class="MenuItem" align="center">
                   十一月
                </td>
                  <td class="MenuItem" align="center">
                  十二月
                </td>
               
            </tr>
            
                <asp:Repeater ID="repeater" runat="server" >
                <ItemTemplate>
                    <tr>
                        <td class="RecordItem" style="text-align:center;  ">
                            &nbsp;<%#Eval("统计")%>
                        </td>
                       
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("一月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("一月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("一月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("二月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("二月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("二月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("三月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("三月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("三月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("四月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("四月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("四月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("五月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("五月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("五月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("六月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("六月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("六月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("七月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("七月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("七月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("八月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("八月")).ToString("#,###.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("八月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("九月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("九月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("九月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                         <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("十月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("十月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("十月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("十一月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("十一月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("十一月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("十二月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("十二月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("十二月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                    </tr>
                </ItemTemplate>
               
            </asp:Repeater>    
            
             <tr>
            <td colspan="13" class="TitleBar"  align="center">
            银行日记账
            </td>
            </tr>
            
              <tr>
                <td class="MenuItem" align="center">
                    项目
                </td>
                
                  <td class="MenuItem" align="center">
                    一月
                </td>
                  <td class="MenuItem" align="center">
                    二月
                </td>
                  <td class="MenuItem" align="center">
                   三月
                </td>
                  <td class="MenuItem" align="center">
                   四月
                </td>
                  <td class="MenuItem" align="center">
                   五月
                </td>
                  <td class="MenuItem" align="center">
                  六月
                </td>
                  <td class="MenuItem" align="center">
                   七月
                </td>
                  <td class="MenuItem" align="center">
                   八月
                </td>
                  <td class="MenuItem" align="center">
                   九月
                </td>
                  <td class="MenuItem" align="center">
                   十月
                </td>
                  <td class="MenuItem" align="center">
                   十一月
                </td>
                  <td class="MenuItem" align="center">
                  十二月
                </td>
               
            </tr>    
              <asp:Repeater ID="repeater1" runat="server" >
                <ItemTemplate>
                    <tr>
                        <td class="RecordItem" style="text-align:center;  ">
                            &nbsp;<%#Eval("统计")%>
                        </td>
                       
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("一月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("一月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("一月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("二月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("二月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("二月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("三月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("三月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("三月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("四月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("四月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("四月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("五月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("五月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("五月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("六月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("六月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("六月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("七月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("七月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("七月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("八月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("八月")).ToString("#,###.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("八月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("九月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("九月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("九月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                         <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("十月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("十月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("十月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("十一月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("十一月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("十一月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                          <td class="RecordItem" style="text-align: center;  ">
                          <%#Eval("十二月").ToString().IndexOf("-") == 0 ? "<span style=\"color:blue;\">" + Convert.ToDouble(Eval("十二月")).ToString("#,##0.00") + "</span>" : "<span style=\"color:#cd0000;\">" + Convert.ToDouble(Eval("十二月")).ToString("#,##0.00") + "</span>"%>
                        </td>
                    </tr>
                </ItemTemplate>
               
            </asp:Repeater>                     
                                    
        </table>
    </div>
    
    
    </form>
</body>
</html>
